<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML+RDFa 1.0//EN" "http://www.w3.org/MarkUp/DTD/xhtml-rdfa-1.dtd">
<?php 
include_once "config/config.php"; 
include_once "functions/genericfunctions.php";
include_once "functions/drawTables.php";
include_once "functions/drawCode.php";
include_once 'UpdateData_brains.php';

?>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title>SQL mokomasis puslapis</title>
    <meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
    <link type="text/css" rel="stylesheet" media="all" href="css/styles.css" />
    <script src="scripts/modernizr-2.0.4.js"></script>
</head>
<body>
    <div id="page-wrapper">
        <div id="page">
            <?php 
            	$_SESSION['psl']=5;
            	include('header1.php'); 
            ?>
            <div class="content">
                <div class="left-side">
                    <?php include('menu-left.html'); ?>
                </div>
                <div class="right-side"> 
            		 <?php 
			    		$_SESSION['upddata'] = GetUzduotis($updatedata_name, $workDB);
            		 	$patterns = array('/\@Lentele_UpdatePvz1/', 
            		 					  '/\@Lentele_UpdatePvz2/',
										  '/\@Kodas_UpdatePvz1/',
										  '/\@Kodas_UpdatePvz2/',
										  '/\@Uzduotis_Update/',
										  '/\@Lentele_UpdateUzduotis/');
						$replacements = array(preUpdate($workDB, $tempDB), 
            		 					      postUpdate($workDB, $tempDB),
										      printCodeUpdate1(),
										      printCodeUpdate2(),
											  $_SESSION['upddata']['salyga'],
											  drawAttrTable($_SESSION['upddata']['pavadinimas']));

            		 	print preg_replace($patterns, $replacements, getTexts($_SESSION['psl'], $workDB));
					  ?>
					    
				    <div>
				        <form class="forma" action="insertQueryUPDATE.php" method="post">
				            <table>
				                <tr><td><textarea cols="50" rows="10" name="sql_code"></textarea></td></tr>
				                <tr><td style="text-align:right;"><input type="submit" value="Atnaujinti" /></td></tr>
				            </table>
				        </form>    	
				    </div>
					    
					    
				</div>
            </div>
              
        
        <?php include('footer.html'); ?>
    </div></div>
    <input type="hidden" id="hid" />

    <script src="http://code.jquery.com/jquery-latest.js"></script>

    <script type="text/javascript" src="scripts/navigacija.js"></script> 	

</body>
</html>